﻿CREATE TABLE [Event].[Events]
(
	EventID INT NOT NULL IDENTITY(1,1), 
	OwnerID INT NOT NULL,
	LocationID INT NULL,
	AttendeeListVisibilityID SMALLINT NOT NULL,
	Title NVARCHAR(255) NOT NULL,
	Description NVARCHAR(1000) NULL,	
	Cost MONEY NOT NULL DEFAULT 0,
	PaymentAccepted BIT NOT NULL DEFAULT 0,
	PaymentRefundable BIT NOT NULL DEFAULT 0,
	InvitationOnly BIT NOT NULL DEFAULT 0,
	Searchable BIT NOT NULL DEFAULT 1,
	SearchEngineURL NVARCHAR(200)
)
